SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_PublicUserSearchEmployerByCorperateType]
    (
      @JOL_Employer_Name VARCHAR(50),
      @JOL_Employer_IsSchoolCorperate BIT
    )
AS 
    SELECT  JOL_Employer_Account,
            JOL_Employer_Name,
            JOL_Employer_Industry,
            JOL_Employer_Type,
			convert(varchar(10),JOL_Employer_VerifyTime,120)		-- doo 20110215  
    FROM    dbo.JOL_Employer
	where JOL_Employer_VerifyStatus = '已审核'	and					-- doo 20110215
		   ( JOL_Employer_Name LIKE '%' + @JOL_Employer_Name + '%' )
            AND JOL_Employer_IsSchoolCorperate = @JOL_Employer_IsSchoolCorperate
    ORDER BY JOL_Employer_VerifyTime,JOL_Employer_AddTime DESC		-- doo 20110215
GO
